<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
    <script>
        // 思考如何将list中的数据转化为最终输出的结果？？？
        const list = [
            {
                correctionTime: "2018-11-30",
                departmentName: "总裁办",
                formOfEmployment: 1,
                id: "604f764971f93f3ac8f365c2",
                mobile: "13800000002",
                password: "e10adc3949ba59abbe56e057f20f883e",
                staffPhoto: "http://q6cu3t6jv.bkt.clouddn.com/1063705989926227968?t=1616204161907",
                timeOfEntry: "2018-11-02",
                username: "管理员",
                workNumber: "9002",
            },
            {
                correctionTime: "2018-11-20",
                departmentName: "市场部",
                formOfEmployment: 1,
                id: "604f764971f93f3ac8f365c3",
                mobile: "13800000003",
                password: "e10adc3949ba59abbe56e057f20f883e",
                staffPhoto: "http://q6cu3t6jv.bkt.clouddn.com/1063705989926227968?t=1616204161907",
                timeOfEntry: "2018-11-04",
                username: "孙财",
                workNumber: "111",
            }
        ]



        function formatToExcel(data) {
            //    中引文的映射对象
            const mapInfo = {
                'id': '编号',
                'password': '密码',
                'mobile': '手机号',
                'username': '姓名',
                'timeOfEntry': '入职日期',
                'formOfEmployment': '聘用形式',
                'correctionTime': '转正日期',
                'workNumber': '工号',
                'departmentName': '部门',
                'staffPhoto': '头像地址'
            }

            // tHeader = ['编号','密码','手机号','姓名','入职日期',.......]
            // 1 生成表头
            // tHeader  ---> ['转正日期', '部门', '聘用形式', '编号', '手机号', '密码', '头像地址', '入职日期', '姓名', '工号']
            const one = list[0]
            if (!one) return
            const tHeader = Object.keys(one).map(en_key => {
                return mapInfo[en_key]
            })
            console.log(tHeader, 'tHeader');
            // 2 生成表的内容data
            const result = list.map(item => {
                return Object.values(item)
            })

            console.log(result, 'data');
           
        }

        formatToExcel(list)











        // data = [
        // ['2018-11-30', '总裁办', 1, '604f764971f93f3ac8f365c2', '13800000002', 'e10adc3949ba59abbe56e057f20f883e', 'http://q6cu3t6jv.bkt.clouddn.com/1063705989926227968?t=1616204161907', '2018-11-02', '管理员', '9002']
        // ,
        // ['2018-11-20', '市场部', 1, '604f764971f93f3ac8f365c3', '13800000003', 'e10adc3949ba59abbe56e057f20f883e', 'http://q6cu3t6jv.bkt.clouddn.com/1063705989926227968?t=1616204161907', '2018-11-04', '孙财', '111']
        // ]


    </script>
</head>

<body>

</body>

</html>